package com.qf.mapper;

import com.qf.entity.TClientBusiness;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;

/*
杨威
2021/11/6
14:55
*/
public interface ClientBusinessMapper {
    @Insert("insert into t_client_business values (0,#{corpName},#{userCode},#{pwd},#{ipAddress},#{isReturnStatus},#{receiveStatusUrl},#{priority},#{userType},#{state},#{mobile},#{money})")
    int insertTClientBusiness(TClientBusiness tClientBusiness);
    @Delete("delete from t_client_business where id=#{id}")
    int deleteTClientBusiness(Long id);
    @Update("update from t_client_business set corpName=#{corpName} and userCode=#{userCode} and pwd=#{pwd} and ipAddress=#{ipAddress} and isReturnStatus=#{isReturnStatus} and receiveStatusUrl=#{receiveStatusUrl} and priority=#{priority} and userType=#{userType} and state=#{state} and mobile=#{mobile} money=#{money}")
    int updateTClientBusiness(TClientBusiness tClientBusiness);
    @Select("select * from t_client_business")
    List<TClientBusiness> findAll();
    @Select("select * from t_client_business where id=#{id}")
    TClientBusiness findById(Long id);
}
